<html>
<%@ page import="java.sql.*" %>
<%!
ResultSet rs=null;
Connection con=null;
 Statement st;
 %>
<%try
{

  Class.forName("oracle.jdbc.driver.OracleDriver");
  con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","bank","bank");
  st=con.createStatement();
 rs=st.executeQuery("select accno from accountdetails");
 st=con.createStatement();
 
}
catch(Exception e){}
 %>
 
 <body bgcolor="#fdfec5">
<center><img src="images/2.jpeg" border=0 width=263 height=128> <img src="images/3.jpeg" border=0 width=263 height=128> <img src="images/4.jpeg" border=0 width=263 height=128> </center>
	 <center><font color="#1589FF" size="5"><b><i><u>Balance Details Of Customer</u></i></b></font></center><br><br><br>     
          <center> <font color="#1589FF" size="4"> &nbsp;&nbsp;&nbsp;&nbsp; <br></font>  </center>
           
            <form action="checkbalance1.jsp" method="POST" name="Rform" >
   <center><table>
   		 <tr><td><font color="red">*</font>Customeraccno</td><td><select name="accno" style="position:absolute;width:89px;left:660px;top:270px;z-index:6">
   		 <%
while(rs.next())
{%>
<option>
<%=rs.getString(1)%></option>
<%}%>
</select></tr>
<tr><td></td><td><input type="submit" value="Submit"></td></tr>
		</table></center>
</form>
</body>
</html>